18CSE301J INFORMATION VISUALIZATION

ROHIT N(RA2011029010007)

TABLEAU PROJECT

The Below Data is visualised and it provides the information of Crime in India.

Visualization of data in python

import pandas as pd  
dataset = pd.read_csv("C:/Users/ROHIT/Documents/ok.csv")

dataset

	State	District	Year	NumberOfCrimes	CrimeType	CrimeGroup	Region
0	Andhra Pradesh	Adilabad	2001	178	MURDER	HOMICIDE	SOUTH
1	Andhra Pradesh	Anantapur	2001	277	MURDER	HOMICIDE	SOUTH
2	Andhra Pradesh	Chittoor	2001	160	MURDER	HOMICIDE	SOUTH
3	Andhra Pradesh	Cuddapah	2001	134	MURDER	HOMICIDE	SOUTH
4	Andhra Pradesh	East Godavari	2001	150	MURDER	HOMICIDE	SOUTH
...	...	...	...	...	...	...	...
203903	Jammu and Kashmir	Srinagar	2014	0	MURDER	HOMICIDE	NORTH
203904	Jammu and Kashmir	Srinagar	2014	0	KIDNAPPING & ABDUCTION	KIDNAPPING & ABDUCTION	NORTH
203905	Jammu and Kashmir	Srinagar	2014	0	OTHER IPC CRIMES	OTHERS	NORTH
203906	Jammu and Kashmir	Srinagar	2014	0	AUTO THEFT	PROPERTY STOLEN	NORTH
203907	Jammu and Kashmir	Srinagar	2014	0	CHEATING	SERIOUS FRAUD	NORTH

203908 rows × 7 columns

import numpy as np
import matplotlib.pyplot as plt
%matplotlib inline
from matplotlib import style

df = dataset.groupby('State',as_index=False)[['NumberOfCrimes']].sum()
state = df['State']
crime = df['NumberOfCrimes']

Ypts = np.arange(len(crime))

import plotly.express as px
fig = px.bar(df, x="NumberOfCrimes", y="State", orientation='h')
fig.show()

import plotly.express as px
df = dataset.groupby('Year',as_index=False)[['NumberOfCrimes']].sum()
px.treemap(data_frame=df,path=['Year'],values='NumberOfCrimes',color='NumberOfCrimes',color_continuous_scale='rdbu')

df = dataset.groupby('Region',as_index=False)[['NumberOfCrimes']].sum()
df

	Region	NumberOfCrimes
0	ARABIAN SEA	858
1	BAY OF BENGAL	10217
2	CENTRAL	3540124
3	EAST	4473617
4	NORTH	7203585
5	NORTH-EAST	1001489
6	SOUTH	8264146
7	WEST	4410987

x = df['Region'].values
y = df['NumberOfCrimes'].values
z = df.index

import plotly.express as px
fig = px.scatter(df,x="Region", y="NumberOfCrimes",
                size="NumberOfCrimes", color="Region",
                    hover_name=df.index,size_max=60)
fig.show()

df = dataset.groupby('District',as_index=False)[['NumberOfCrimes']].sum()
names = df['District']
values = df['NumberOfCrimes']

fig = px.pie(df,
            names = names,
            values = values,
            title = 'District wise crimes'
            )

fig.update_traces(
            textposition = 'inside',
            textinfo = 'percent+label'
            )

fig.update_layout(
            title_font_size = 42
            )

fig.show()

Visualization in Gephi